loading packages

## ── Attaching packages ─────────────────────────────────────── tidyverse 1.3.2 ──
## ✔ ggplot2 3.4.0      ✔ purrr   0.3.5 
## ✔ tibble  3.1.8      ✔ dplyr   1.0.10
## ✔ tidyr   1.2.1      ✔ stringr 1.4.1 
## ✔ readr   2.1.3      ✔ forcats 0.5.2 
## ── Conflicts ────────────────────────────────────────── tidyverse_conflicts() ──
## ✖ dplyr::filter() masks stats::filter()
## ✖ dplyr::lag()    masks stats::lag()
## Loading required package: timechange
## 
## 
## Attaching package: 'lubridate'
## 
## 
## The following objects are masked from 'package:base':
## 
##     date, intersect, setdiff, union
## Rows: 8 Columns: 149
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr   (3): SLDUST, NAMELSAD, NAME
## dbl (146): OBJECTID, STATEFP, GEOID, ALAND, AWATER, INTPTLAT, INTPTLON, DP03...
## 
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.
## Rows: 273498 Columns: 58
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr (13): CCN, REPORTDATE, ROUTEID, FROMDATE, ADDRESS, WARD, EVENTID, MAR_AD...
## dbl (44): X, Y, OBJECTID, CRIMEID, MEASURE, OFFSET, STREETSEGID, ROADWAYSEGI...
## lgl  (1): TODATE
## 
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.
## Rows: 721264 Columns: 15
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr (11): CCN, PERSONTYPE, FATAL, MAJORINJURY, MINORINJURY, VEHICLEID, INVEH...
## dbl  (4): OBJECTID, CRIMEID, PERSONID, AGE
## 
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.
## Rows: 60094 Columns: 18
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr  (3): COMMENTS, GIS_ID, GLOBALID
## dbl (10): X, Y, STREETJUNCTIONID, STREETSEGID, FACILITYID, MARKINGID, MARKIN...
## lgl  (5): SE_ANNO_CAD_DATA, CREATOR, CREATED, EDITOR, EDITED
## 
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.
## Rows: 71720 Columns: 61
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr (45): ADDEDBY, ADDTOGIS, ARMLENGTH1_DESC, ARMLENGTH2_DESC, ARMSTYLE_DESC...
## dbl (10): X, Y, ASSETTYPE, NUMBERLIGHTS, STREETSEGMID, WARD, WATTAGE1, XCOOR...
## lgl  (6): GLOBALID, GIS_ID, CREATOR, CREATED, EDITOR, EDITED
## 
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.
## Rows: 314 Columns: 17
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr (5): CAMERATYPE, GIS_ID, GLOBALID, EDITOR, EDITED
## dbl (9): X, Y, STREETJUNCTIONID, STREETSEGID, FACILITYID, CAMERAID, POLEID, ...
## lgl (3): SE_ANNO_CAD_DATA, CREATOR, CREATED
## 
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.
## Rows: 55 Columns: 25
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr (8): FACILITYID, STATIONID, STATIONABBR, STATIONTYPE, TECHNOLOGY, ADDRES...
## dbl (9): X, Y, STREETSEGID, SISID, MEASURE, MAPINSET, XCOORD, YCOORD, OBJECTID
## lgl (8): CONDITION, CONDITIONDATE, INSTALLDATE, SE_ANNO_CAD_DATA, CREATOR, C...
## 
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.
## Rows: 1412 Columns: 17
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr  (2): GIS_ID, GLOBALID
## dbl (10): X, Y, STREETJUNCTIONID, STREETSEGID, FACILITYID, CABINETID, CABINE...
## lgl  (5): SE_ANNO_CAD_DATA, CREATOR, CREATED, EDITOR, EDITED
## 
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.

find common variables

##  [1] "X"          "Y"          "FACILITYID" "GLOBALID"   "GIS_ID"    
##  [6] "OBJECTID"   "CREATOR"    "CREATED"    "EDITOR"     "EDITED"
## # A tibble: 721,264 × 15
##     OBJECTID  CRIMEID CCN    PERSO…¹ PERSO…²   AGE FATAL MAJOR…³ MINOR…⁴ VEHIC…⁵
##        <dbl>    <dbl> <chr>    <dbl> <chr>   <dbl> <chr> <chr>   <chr>   <chr>  
##  1 368933829 25173932 14167…  8.46e7 Driver     31 N     N       N       1001107
##  2 368933830 24125385 12105…  8.50e7 Driver     25 N     N       N       862546 
##  3 371097543 24125385 12105…  8.47e7 Driver     NA N     N       N       862545 
##  4 371097544 26652669 09087…  8.50e7 Driver     NA N     N       N       985829 
##  5 371097545 26652669 09087…  8.48e7 Passen…    NA N     N       N       985828 
##  6 371097546 26652669 09087…  8.47e7 Driver     10 N     N       N       985828 
##  7 371097547 26652669 09087…  8.48e7 Passen…    NA N     N       N       985828 
##  8 371097548 26652671 08120…  8.48e7 Driver     42 N     N       N       985879 
##  9 371097549 26652671 08120…  8.49e7 Driver     21 N     N       N       985880 
## 10 371097550 26651388 10174…  8.48e7 Driver     25 N     N       Y       902286 
## # … with 721,254 more rows, 5 more variables: INVEHICLETYPE <chr>,
## #   TICKETISSUED <chr>, LICENSEPLATESTATE <chr>, IMPAIRED <chr>,
## #   SPEEDING <chr>, and abbreviated variable names ¹​PERSONID, ²​PERSONTYPE,
## #   ³​MAJORINJURY, ⁴​MINORINJURY, ⁵​VEHICLEID
## # A tibble: 1 × 58
##       X     Y  OBJECTID  CRIMEID CCN      REPOR…¹ ROUTEID MEASURE OFFSET STREE…²
##   <dbl> <dbl>     <dbl>    <dbl> <chr>    <chr>   <chr>     <dbl>  <dbl>   <dbl>
## 1 -77.0  38.9 140193753 23522156 10170915 2010/1… 110872…   1395.   25.2      -9
## # … with 48 more variables: ROADWAYSEGID <dbl>, FROMDATE <chr>, TODATE <lgl>,
## #   ADDRESS <chr>, LATITUDE <dbl>, LONGITUDE <dbl>, XCOORD <dbl>, YCOORD <dbl>,
## #   WARD <chr>, EVENTID <chr>, MAR_ADDRESS <chr>, MAR_SCORE <dbl>,
## #   MAJORINJURIES_BICYCLIST <dbl>, MINORINJURIES_BICYCLIST <dbl>,
## #   UNKNOWNINJURIES_BICYCLIST <dbl>, FATAL_BICYCLIST <dbl>,
## #   MAJORINJURIES_DRIVER <dbl>, MINORINJURIES_DRIVER <dbl>,
## #   UNKNOWNINJURIES_DRIVER <dbl>, FATAL_DRIVER <dbl>, …
## # A tibble: 2 × 15
##    OBJECTID  CRIMEID CCN     PERSO…¹ PERSO…²   AGE FATAL MAJOR…³ MINOR…⁴ VEHIC…⁵
##       <dbl>    <dbl> <chr>     <dbl> <chr>   <dbl> <chr> <chr>   <chr>   <chr>  
## 1 371164304 23522156 101709…  8.49e7 Driver      0 N     N       N       899452 
## 2 371559170 23522156 101709…  8.49e7 Driver     33 N     N       N       899453 
## # … with 5 more variables: INVEHICLETYPE <chr>, TICKETISSUED <chr>,
## #   LICENSEPLATESTATE <chr>, IMPAIRED <chr>, SPEEDING <chr>, and abbreviated
## #   variable names ¹​PERSONID, ²​PERSONTYPE, ³​MAJORINJURY, ⁴​MINORINJURY,
## #   ⁵​VEHICLEID
## # A tibble: 1 × 58
##       X     Y  OBJECTID  CRIMEID CCN      REPOR…¹ ROUTEID MEASURE OFFSET STREE…²
##   <dbl> <dbl>     <dbl>    <dbl> <chr>    <chr>   <chr>     <dbl>  <dbl>   <dbl>
## 1 -77.0  38.9 140193753 23522156 10170915 2010/1… 110872…   1395.   25.2      -9
## # … with 48 more variables: ROADWAYSEGID <dbl>, FROMDATE <chr>, TODATE <lgl>,
## #   ADDRESS <chr>, LATITUDE <dbl>, LONGITUDE <dbl>, XCOORD <dbl>, YCOORD <dbl>,
## #   WARD <chr>, EVENTID <chr>, MAR_ADDRESS <chr>, MAR_SCORE <dbl>,
## #   MAJORINJURIES_BICYCLIST <dbl>, MINORINJURIES_BICYCLIST <dbl>,
## #   UNKNOWNINJURIES_BICYCLIST <dbl>, FATAL_BICYCLIST <dbl>,
## #   MAJORINJURIES_DRIVER <dbl>, MINORINJURIES_DRIVER <dbl>,
## #   UNKNOWNINJURIES_DRIVER <dbl>, FATAL_DRIVER <dbl>, …
## # A tibble: 0 × 15
## # … with 15 variables: OBJECTID <dbl>, CRIMEID <dbl>, CCN <chr>,
## #   PERSONID <dbl>, PERSONTYPE <chr>, AGE <dbl>, FATAL <chr>,
## #   MAJORINJURY <chr>, MINORINJURY <chr>, VEHICLEID <chr>, INVEHICLETYPE <chr>,
## #   TICKETISSUED <chr>, LICENSEPLATESTATE <chr>, IMPAIRED <chr>, SPEEDING <chr>

combine data

## # A tibble: 1 × 69
##       X     Y CRIMEID   CCN REPORTDATE ROUTEID MEASURE OFFSET STREETSE…¹ ROADW…²
##   <int> <int>   <int> <int>      <int>   <int>   <int>  <int>      <int>   <int>
## 1     0     0       0     0       2549       0       0      0     144311  144311
## # … with 59 more variables: FROMDATE <int>, TODATE <int>, ADDRESS <int>,
## #   LATITUDE <int>, LONGITUDE <int>, XCOORD <int>, YCOORD <int>, WARD <int>,
## #   EVENTID <int>, MAR_ADDRESS <int>, MAR_SCORE <int>,
## #   MAJORINJURIES_BICYCLIST <int>, MINORINJURIES_BICYCLIST <int>,
## #   UNKNOWNINJURIES_BICYCLIST <int>, FATAL_BICYCLIST <int>,
## #   MAJORINJURIES_DRIVER <int>, MINORINJURIES_DRIVER <int>,
## #   UNKNOWNINJURIES_DRIVER <int>, FATAL_DRIVER <int>, …
## # A tibble: 1 × 58
##       X     Y CRIMEID   CCN REPORTDATE ROUTEID MEASURE OFFSET FROMDATE ADDRESS
##   <int> <int>   <int> <int>      <int>   <int>   <int>  <int>    <int>   <int>
## 1     0     0       0     0       2549       0       0      0      560     192
## # … with 48 more variables: LATITUDE <int>, LONGITUDE <int>, XCOORD <int>,
## #   YCOORD <int>, WARD <int>, MAR_SCORE <int>, MAJORINJURIES_BICYCLIST <int>,
## #   MINORINJURIES_BICYCLIST <int>, UNKNOWNINJURIES_BICYCLIST <int>,
## #   FATAL_BICYCLIST <int>, MAJORINJURIES_DRIVER <int>,
## #   MINORINJURIES_DRIVER <int>, UNKNOWNINJURIES_DRIVER <int>,
## #   FATAL_DRIVER <int>, MAJORINJURIES_PEDESTRIAN <int>,
## #   MINORINJURIES_PEDESTRIAN <int>, UNKNOWNINJURIES_PEDESTRIAN <int>, …

## `geom_smooth()` using method = 'gam' and formula = 'y ~ s(x, bs = "cs")'

## `geom_smooth()` using method = 'loess' and formula = 'y ~ x'

## `geom_smooth()` using method = 'loess' and formula = 'y ~ x'

## `geom_smooth()` using method = 'loess' and formula = 'y ~ x'